﻿CREATE TABLE [dbo].[Customer] (
    [TelefonNr] INT           NOT NULL,
    [Navn]      NVARCHAR (50) NOT NULL,
    [Gade]      NVARCHAR (50) NOT NULL,
    [PostNr]    INT           NOT NULL,
    [By]        NVARCHAR (50) NOT NULL,
    [Oprettet]  DATETIME      NOT NULL,
    [Email]     NVARCHAR (50) NOT NULL,
    [CreditLimit] MONEY NOT NULL, 
    [Approved] BIT NOT NULL, 
    CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED ([TelefonNr] ASC)
);

